CREATE TABLE [dbo].[TTBANC_AGEN]
(
[CO_BANC] [dbo].[TD_VC_003] NOT NULL,
[CO_AGEN] [dbo].[TD_VC_003] NOT NULL,
[DE_NOMB_AGEN] [dbo].[TD_VC_050] NULL,
[CO_UBIC_GEOG] [dbo].[TD_VC_006] NULL,
[DE_DIRE_AGEN] [dbo].[TD_VC_050] NULL,
[NU_TEL1] [dbo].[TD_VC_050] NULL,
[NU_TEL2] [dbo].[TD_VC_050] NULL,
[NU_TFAX] [dbo].[TD_VC_050] NULL,
[DE_NOMB_SECT] [dbo].[TD_VC_100] NULL,
[DE_MAIL] [dbo].[TD_VC_050] NULL,
[TI_SITU] [dbo].[TD_VC_003] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TTBANC_AG__CO_US__0AC87E64] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTBANC_AG__FE_US__0BBCA29D] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TTBANC_AG__CO_US__0CB0C6D6] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTBANC_AG__FE_US__0DA4EB0F] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTBANC_AGEN] ADD CONSTRAINT [PK__TTBANC_A__8B3B09BE5907059E] PRIMARY KEY CLUSTERED  ([CO_BANC], [CO_AGEN]) ON [PRIMARY]
GO
